﻿CREATE TABLE [dbo].[DimEB_271]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[InfoSource_NM109_SourcePrimaryID] [nvarchar] (100) NULL,
[InfoSource_REF03_PlanName] [nvarchar] (100) NULL,
[Subscriber_TRN01_TraceTypeCode] [nvarchar] (50) NULL,
[Subscriber_TRN02_TraceNumber] [nvarchar] (50) NULL,
[Subscriber_TRN03_TraceAssigningEntityID] [nvarchar] (50) NULL,
[Subscriber_TRN04_TraceAssigningEntityAdditionalID] [nvarchar] (50) NULL,
[Subscriber_NM109_SubscriberPrimaryIdentifier] [nvarchar] (100) NULL,
[IsDependent] [nvarchar] (50) NULL,
[ReceiveResponse] [datetime] NULL,
[Subscriber_REF02_SubscriberSupplementalID] [nvarchar] (50) NULL,
[Subscriber_REF03_PlanSponsorName] [nvarchar] (100) NULL,
[Subscriber_AAA01_ValidRequestIndicator] [nvarchar] (50) NULL,
[Subscriber_AAA03_RejectReasonCode] [nvarchar] (50) NULL,
[Subscriber_AAA04_FollowupActionCode] [nvarchar] (50) NULL,
[BHT03_SubmitterTransactionIdentifier] [nvarchar] (50) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[Receive_UTC] [datetime] NULL,
[EB271_ID_Key] [int] NOT NULL IDENTITY(1, 1),
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[InsertDate] [datetime] NULL
) ON [PRIMARY]


